SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[BancosInsertCommand]
(
	@ID numeric(10, 0),
	@BANCO varchar(70),
	@ACTIVO bit
)
AS

SET NOCOUNT OFF;

DECLARE @I NUMERIC(10,0) = (SELECT(ISNULL(MAX([BANCOS].ID),0))+1 FROM [BANCOS]);

INSERT INTO [BANCOS] ([ID], [BANCO], [ACTIVO]) VALUES (@I, @BANCO, @ACTIVO);
	
SELECT ID, BANCO, ACTIVO FROM BANCOS WHERE (ID = @I)
GO
